import sqlite3

# Connect to the database
conn = sqlite3.connect('../databases/example.db')

# Create a cursor object
cursor = conn.cursor()

# Create a table
cursor.execute('''CREATE TABLE IF NOT EXISTS users
                 (id INTEGER PRIMARY KEY, name TEXT, email TEXT)''')

# Insert data into the table
cursor.execute("INSERT INTO users (name, email) VALUES (?,?)", ('John Doe', 'johndoe@example.com'))

# Commit the changes
conn.commit()

# Fetch data from the table
cursor.execute("SELECT * FROM users")
rows = cursor.fetchall()

# Print the data
for row in rows:
    print(row)

# Close the connection
conn.close()